CREATE TABLE [dbo].[ReceiptLine]
(
[ReceiptLineKey] [uniqueidentifier] NOT NULL,
[ReceiptKey] [uniqueidentifier] NOT NULL,
[ReceiptedAmount] [decimal] (18, 4) NOT NULL,
[PaymentKey] [uniqueidentifier] NOT NULL,
[LineNumber] [int] NOT NULL,
[LineDescription] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProductKey] [uniqueidentifier] NOT NULL,
[SourceReceiptLineKey] [uniqueidentifier] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ReceiptLine] ADD CONSTRAINT [PK_ReceiptLine] PRIMARY KEY CLUSTERED ([ReceiptLineKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ReceiptLine_ReceiptKey] ON [dbo].[ReceiptLine] ([ReceiptKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ReceiptLine_SourceReceiptLineKey] ON [dbo].[ReceiptLine] ([SourceReceiptLineKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ReceiptLine] ADD CONSTRAINT [FK_ReceiptLine_PaymentMain] FOREIGN KEY ([PaymentKey]) REFERENCES [dbo].[PaymentMain] ([PaymentKey])
GO
ALTER TABLE [dbo].[ReceiptLine] ADD CONSTRAINT [FK_ReceiptLine_Receipt] FOREIGN KEY ([ReceiptKey]) REFERENCES [dbo].[ReceiptMain] ([ReceiptKey])
GO
ALTER TABLE [dbo].[ReceiptLine] ADD CONSTRAINT [FK_ReceiptLine_ReceiptLine] FOREIGN KEY ([SourceReceiptLineKey]) REFERENCES [dbo].[ReceiptLine] ([ReceiptLineKey])
GO